<?php

class SpotFixture extends CakeTestFixture {
	
	public $import = array('table' => 'spots', 'records' => false, 'connection' => 'development');
	
	public function init() {
		$this->records = array (
			array(
				'id' => 1,
				'name' => 'My Spot Record',
				'description' => 'This is a simple description for "My Spot Record".',
				'address' => 'A useful address.',
				'picture' => null,
				'position' => 'GeomFromText("POINT(40.834 -73.998)")',
				'city_id' => 1,
				'category_id' => 1,
				'created' => date('Y-m-d h:i:s'),
				'updated' => date('Y-m-d h:i:s')
			),
			array(
				'id' => 2,
				'name' => 'Yet Another Spot',
				'description' => 'This is a simple description for "Yet Another Spot".',
				'address' => '5th Avenue, New York.',
				'picture' => null,
				'position' => sprintf('GeomFromText("POINT(%f %f)")', 40.677, -74.008),	// New York
				'city_id' => 1,
				'category_id' => 1,
				'created' => date('Y-m-d h:i:s'),
				'updated' => date('Y-m-d h:i:s')
			)
		);
		parent::init();
	}
	
}